Create Grade Levels


DECLARE	@return_value int

EXEC	@return_value = [dbo].[WriteDataToDB]
		@RequestorEntityID = 0,
		@DataTableType = N'Entity',
		@JSONData = N'{ "EntityType": "GradeInSchool", "GradeName": "K", "EntityID": "-1", "ShortRelationshipName": "SC_HasGrade", "Entity1ID": "10000" }',
		@DataID = -1

SELECT	'Return Value' = @return_value

GO
EXEC	[dbo].[WriteDataToDB]
		@RequestorEntityID = 0,
		@DataTableType = N'Entity',
		@JSONData = N'{ "EntityType": "GradeInSchool", "GradeName": "1", "EntityID": "-1", "ShortRelationshipName": "SC_HasGrade", "Entity1ID": "10000" }',
		@DataID = -1
GO
EXEC	[dbo].[WriteDataToDB]
		@RequestorEntityID = 0,
		@DataTableType = N'Entity',
		@JSONData = N'{ "EntityType": "GradeInSchool", "GradeName": "2", "EntityID": "-1", "ShortRelationshipName": "SC_HasGrade", "Entity1ID": "10000" }',
		@DataID = -1
GO
EXEC	[dbo].[WriteDataToDB]
		@RequestorEntityID = 0,
		@DataTableType = N'Entity',
		@JSONData = N'{ "EntityType": "GradeInSchool", "GradeName": "3", "EntityID": "-1", "ShortRelationshipName": "SC_HasGrade", "Entity1ID": "10000" }',
		@DataID = -1
GO
EXEC	[dbo].[WriteDataToDB]
		@RequestorEntityID = 0,
		@DataTableType = N'Entity',
		@JSONData = N'{ "EntityType": "GradeInSchool", "GradeName": "4", "EntityID": "-1", "ShortRelationshipName": "SC_HasGrade", "Entity1ID": "10000" }',
		@DataID = -1
GO
EXEC	[dbo].[WriteDataToDB]
		@RequestorEntityID = 0,
		@DataTableType = N'Entity',
		@JSONData = N'{ "EntityType": "GradeInSchool", "GradeName": "5", "EntityID": "-1", "ShortRelationshipName": "SC_HasGrade", "Entity1ID": "10000" }',
		@DataID = -1
GO
EXEC	[dbo].[WriteDataToDB]
		@RequestorEntityID = 0,
		@DataTableType = N'Entity',
		@JSONData = N'{ "EntityType": "GradeInSchool", "GradeName": "6", "EntityID": "-1", "ShortRelationshipName": "SC_HasGrade", "Entity1ID": "10000" }',
		@DataID = -1
GO
EXEC	[dbo].[WriteDataToDB]
		@RequestorEntityID = 0,
		@DataTableType = N'Entity',
		@JSONData = N'{ "EntityType": "GradeInSchool", "GradeName": "7", "EntityID": "-1", "ShortRelationshipName": "SC_HasGrade", "Entity1ID": "10000" }',
		@DataID = -1
GO
EXEC	[dbo].[WriteDataToDB]
		@RequestorEntityID = 0,
		@DataTableType = N'Entity',
		@JSONData = N'{ "EntityType": "GradeInSchool", "GradeName": "8", "EntityID": "-1", "ShortRelationshipName": "SC_HasGrade", "Entity1ID": "10000" }',
		@DataID = -1
GO
EXEC	[dbo].[WriteDataToDB]
		@RequestorEntityID = 0,
		@DataTableType = N'Entity',
		@JSONData = N'{ "EntityType": "GradeInSchool", "GradeName": "9", "EntityID": "-1", "ShortRelationshipName": "SC_HasGrade", "Entity1ID": "10000" }',
		@DataID = -1
GO
EXEC	[dbo].[WriteDataToDB]
		@RequestorEntityID = 0,
		@DataTableType = N'Entity',
		@JSONData = N'{ "EntityType": "GradeInSchool", "GradeName": "10", "EntityID": "-1", "ShortRelationshipName": "SC_HasGrade", "Entity1ID": "10000" }',
		@DataID = -1
GO
EXEC	[dbo].[WriteDataToDB]
		@RequestorEntityID = 0,
		@DataTableType = N'Entity',
		@JSONData = N'{ "EntityType": "GradeInSchool", "GradeName": "11", "EntityID": "-1", "ShortRelationshipName": "SC_HasGrade", "Entity1ID": "10000" }',
		@DataID = -1
GO
EXEC	[dbo].[WriteDataToDB]
		@RequestorEntityID = 0,
		@DataTableType = N'Entity',
		@JSONData = N'{ "EntityType": "GradeInSchool", "GradeName": "12", "EntityID": "-1", "ShortRelationshipName": "SC_HasGrade", "Entity1ID": "10000" }',
		@DataID = -1
GO